FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetView Class > SetConditionalFormatting Method : SetConditionalFormatting(Int32,Int32,Int32,Int32,Boolean,IConditionalFormattingRule[]) Method |
'Declaration Public Overloads Sub SetConditionalFormatting( _ ByVal row As Integer, _ ByVal column As Integer, _ ByVal rowCount As Integer, _ ByVal columnCount As Integer, _ ByVal combinable As Boolean, _ ByVal ParamArray rules() As IConditionalFormattingRule _ )
'Usage Dim instance As SheetView Dim row As Integer Dim column As Integer Dim rowCount As Integer Dim columnCount As Integer Dim combinable As Boolean Dim rules() As IConditionalFormattingRule instance.SetConditionalFormatting(row, column, rowCount, columnCount, combinable, rules)
public void SetConditionalFormatting( int row, int column, int rowCount, int columnCount, bool combinable, params IConditionalFormattingRule[] rules )
protected void Page_Load(object sender, System.EventArgs e) { FpSpread1.Sheets[0].Cells[0, 0].Value = 3; FpSpread1.Sheets[0].Cells[1, 0].Value = 2; FpSpread1.Sheets[0].Cells[1, 1].Value = 10; FpSpread1.Sheets[0].Cells[0, 2].Value = 1; } protected void Button1_Click(object sender, EventArgs e) { FarPoint.Web.Spread.UnaryComparisonConditionalFormattingRule unary = new FarPoint.Web.Spread.UnaryComparisonConditionalFormattingRule(FarPoint.Web.Spread.UnaryComparisonOperator.EqualTo, 10); unary.Operator = FarPoint.Web.Spread.UnaryComparisonOperator.EqualTo; unary.Value = 10; unary.BackColor = Color.Red; unary.FontStyle = new FarPoint.Web.Spread.SpreadFontStyle(FarPoint.Web.Spread.UnderlineFontStyle.None); unary.FontStyle.RegularBoldItalic = FarPoint.Web.Spread.RegularBoldItalicFontStyle.Bold; FarPoint.Web.Spread.BetweenValuesConditionalFormattingRule between = new FarPoint.Web.Spread.BetweenValuesConditionalFormattingRule(false, 1, false, 20, false); between.FirstValue = 1; between.SecondValue = 20; between.IsNotBetween = true; between.BackColor = Color.Bisque; //SetConditionalFormatting Overload FpSpread1.ActiveSheetView.SetConditionalFormatting(0, 0, 3, 3, false, unary, between); //FpSpread1.ActiveSheetView.SetConditionalFormatting(new FarPoint.Web.Spread.Model.CellRange[] { new FarPoint.Web.Spread.Model.CellRange(1, 1, 2, 3), new FarPoint.Web.Spread.Model.CellRange(1, 2, 2, 1) }, unary, between); //FpSpread1.ActiveSheetView.SetConditionalFormatting(new FarPoint.Web.Spread.Model.CellRange[] { new FarPoint.Web.Spread.Model.CellRange(1, 1, 2, 3), new FarPoint.Web.Spread.Model.CellRange(1, 2, 2, 1) }, FarPoint.Web.Spread.ConditionalFormattingCompactMode.Solid, unary); //FpSpread1.ActiveSheetView.SetConditionalFormatting(1, 1, unary); //FpSpread1.ActiveSheetView.SetConditionalFormatting(1, 1, false, unary); //FpSpread1.ActiveSheetView.SetConditionalFormatting(0, 0, 3, 3, unary, between); //FpSpread1.ActiveSheetView.SetConditionalFormatting(0, 0, 3, 3, false, unary); }
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load FpSpread1.Sheets(0).Cells(0, 0).Value = 3 FpSpread1.Sheets(0).Cells(1, 0).Value = 2 FpSpread1.Sheets(0).Cells(1, 1).Value = 10 FpSpread1.Sheets(0).Cells(0, 2).Value = 1 End Sub Dim unary As New FarPoint.Web.Spread.UnaryComparisonConditionalFormattingRule(FarPoint.Web.Spread.UnaryComparisonOperator.EqualTo, 10) unary.Operator = FarPoint.Web.Spread.UnaryComparisonOperator.EqualTo unary.Value = 10 unary.BackColor = Drawing.Color.Red unary.FontStyle = New FarPoint.Web.Spread.SpreadFontStyle(FarPoint.Web.Spread.UnderlineFontStyle.None) unary.FontStyle.RegularBoldItalic = FarPoint.Web.Spread.RegularBoldItalicFontStyle.Bold Dim between As New FarPoint.Web.Spread.BetweenValuesConditionalFormattingRule(False, 1, False, 20, False) between.FirstValue = 1 between.SecondValue = 20 between.IsNotBetween = True between.BackColor = Drawing.Color.Bisque 'SetConditionalFormatting Overload FpSpread1.ActiveSheetView.SetConditionalFormatting(0, 0, 3, 3, False, unary, between) 'FpSpread1.ActiveSheetView.SetConditionalFormatting(New FarPoint.Web.Spread.Model.CellRange() {New FarPoint.Web.Spread.Model.CellRange(1, 1, 2, 3), New FarPoint.Web.Spread.Model.CellRange(1, 2, 2, 1)}, unary, between) 'FpSpread1.ActiveSheetView.SetConditionalFormatting(New FarPoint.Web.Spread.Model.CellRange() {New FarPoint.Web.Spread.Model.CellRange(1, 1, 2, 3), New FarPoint.Web.Spread.Model.CellRange(1, 2, 2, 1)}, FarPoint.Web.Spread.ConditionalFormattingCompactMode.Solid, unary) 'FpSpread1.ActiveSheetView.SetConditionalFormatting(1, 1, unary) 'FpSpread1.ActiveSheetView.SetConditionalFormatting(1, 1, False, unary) 'FpSpread1.ActiveSheetView.SetConditionalFormatting(0, 0, 3, 3, unary, between) 'FpSpread1.ActiveSheetView.SetConditionalFormatting(0, 0, 3, 3, False, unary)
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6